<?php
$host="db.seng.uvic.ca"; // Host name
$username="se321g01"; // Mysql username
$password="un8bi2YM"; // Mysql password
$db_name="se321g01"; // Database name
$tbl_name="rewards_info"; // Table name

// Connect to server and select databse.
mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");

// Rewards Description
$product_name = "Starbucks Card",
$company_name = "Starbucks",
$picture = "H:\seng321\Project\prototype\images\rewards\rewards1",
$product_description  = "this is a startbucks card",
$price = "1000",


// Update into user_info
mysql_query("INSERT rewards_info
SET product_name='$product_name', company_name='$company_name', picture='$picture', product_description='$product_description', price = '$price'");
?>
